53828 - Reading a DB2 table that contains a BLOB or CLOB data type might result in errors

Problem Note 53828: Reading a DB2 table that contains a BLOB or CLOB data type might result in errors

Querying a DB2 table and explicitly listing a column of a BLOB (binary large object) or CLOB (character large object) data type in the SELECT clause might result in an error similar to the following:

DB2 ERROR:                                                                   
RESULT OF SQL STATEMENT:                                                     
DSN00804E AN ERROR WAS FOUND IN THE APPLICATION PROGRAM INPUT PARAMETERS FOR THE SQL STATEMENT, REASON 17                                  
A DUMP OF THE SQLCA FOR THE GET DIAGNOSTICS REQUEST FOLLOWS:                 
           ROW NUMBER: 0 ERROR CONDITION: 1 REASON CODE: 17                   
           SQLCODE: -804 SQLSTATE: 07002 SQLERRP: DSNXROHB

To work around this issue, select all variables by specifying SELECT * in your query.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

Product Family	Product	System	SAS Release
			Reported	Fixed*
SAS System	SAS/ACCESS Interface to DB2	z/OS	9.3 TS1M2	9.4 TS1M2

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

A fix for this issue for SAS/ACCESS Interface to DB2 9.3_M2 is available at:

https://tshf.sas.com/techsup/download/hotfix/HF2/J41.html#53828

Type:	Problem Note
Priority:	high

Date Modified:	2014-12-18 10:07:49
Date Created:	2014-08-04 14:42:26

Support

Problem Note 53828: Reading a DB2 table that contains a BLOB or CLOB data type might result in errors

Operating System and Release Information